[dbo].[BAECartBillingDelete]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartBillingDelete

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@CartBillingId	int	4

SQL Script

create procedure [dbo].[BAECartBillingDelete] @CartBillingId int as
DECLARE @cartItemId AS int;
    SELECT @cartItemId = CartItemId FROM CartBilling WHERE CartBillingId = @CartBillingId;

    DELETE FROM CartBilling WHERE CartBillingId = @CartBillingId;

    DELETE FROM CartItem WHERE CartItemID = @cartItemId;

GO

Uses

[dbo].[CartBilling]
[dbo].[CartItem]
dbo